<?xml version="1.0" encoding="utf-8" ?>
<definition>
  <!-- FULL SCRIPT FOR DATABASE -->
  <script></script>
<!-- TESTCLASSES -->
  <class id="TestClass">
    <!-- TestClass CLASS -->
    <name>TestClass</name>
    <!-- Classname -->
    <change>create</change>
    <!-- Activity for Class -->
    <BackEndDef></BackEndDef>
    <attribute>
      <!-- testproperty -->
      <change></change>
      <name>testproperty</name>
      <type>nText</type>
      <key>0</key>
      <index>0</index>
      <nullable></nullable>
    </attribute>
  </class>
  <class id="TestClass2">
      <!-- TestClass2 TESTCLASS -->
      <name>TestClass2</name>
      <!-- Classname -->
      <change>create</change>
      <!-- Activity for Class -->
      <BackEndDef></BackEndDef>
      <attribute>
        <!-- testproperty -->
        <change></change>
        <name>testproperty</name>
        <type>nText</type>
        <key>0</key>
        <index>0</index>
        <nullable></nullable>
      </attribute>
    </class>
  <class id='Author2' >
      <!-- AUTHOR2 TEST CLASS -->
      <name>Author2</name>
      <!-- Classname -->
      <change>create</change>
      <!-- Activity for Class -->
      <BackEndDef></BackEndDef>
      <!-- Script for Creation -->
      <attribute>
        <!-- firstname -->
        <change></change>
        <name>firstname</name>
        <type>nVarchar(MAX)</type>
        <key>0</key>
        <index>0</index>
        <nullable>NOT NULL</nullable>
      </attribute>
      <attribute>
        <!-- lastname -->
        <change></change>
        <name>lastname</name>
        <type>nVarchar(MAX)</type>
        <key>0</key>
        <index>0</index>
        <nullable>NOT NULL</nullable>
      </attribute>
      <refAttribute>
        <!-- REFTEST Book2 -->
        <change></change>
        <name>Books</name>
        <refClass>Book2</refClass>
        <refClassAttrName>Authors</refClassAttrName>
        <refTable>ref_author2_book2_01</refTable>
        <index>0</index>
        <BackEndDef></BackEndDef>
      </refAttribute>
    </class>
  <class id='Book2' >
      <!-- BOOK2 TEST CLASS -->
      <name>Book2</name>
      <!-- Classname -->
      <change>create</change>
      <!-- Activity for Class -->
      <BackEndDef></BackEndDef>
      <!-- Script for Creation -->
      <attribute>
        <!--title-->
        <change></change>
        <name>title</name>
        <type>nVarchar(MAX)</type>
        <key>0</key>
        <index>0</index>
        <nullable>NOT NULL</nullable>
      </attribute>
      <attribute>
        <!-- description -->
        <change></change>
        <name>description</name>
        <type>nVarchar(MAX)</type>
        <key>0</key>
        <index>0</index>
        <nullable></nullable>
      </attribute>
      <attribute>
        <!--pages -->
        <change></change>
        <name>pages</name>
        <type>int</type>
        <key>0</key>
        <index>0</index>
        <nullable></nullable>
      </attribute>
      <attribute>
        <!--readbook -->
        <change></change>
        <name>readbook</name>
        <type>bit</type>
        <key>0</key>
        <index>0</index>
        <nullable></nullable>
      </attribute>
      <attribute>
        <!-- price -->
        <change></change>
        <name>price</name>
        <type>float</type>
        <key>0</key>
        <index>0</index>
        <nullable></nullable>
      </attribute>
      <attribute>
        <!-- ISBN10 -->
        <change></change>
        <name>ISBN10</name>
        <type>nVarchar(20)</type>
        <key>0</key>
        <index>0</index>
        <nullable></nullable>
      </attribute>
      <attribute>
        <!-- ISBN13 -->
        <change></change>
        <name>ISBN13</name>
        <type>nVarchar(20)</type>
        <key>0</key>
        <index>0</index>
        <nullable></nullable>
      </attribute>
      <attribute>
        <!-- editiontype -->
        <change></change>
        <name>editiontype</name>
        <type>nVarchar(25)</type>
        <key>0</key>
        <index>0</index>
        <nullable></nullable>
      </attribute>
      <attribute>
        <!-- year -->
        <change></change>
        <name>year</name>
        <type>nVarchar(5)</type>
        <key>0</key>
        <index>0</index>
        <nullable></nullable>
      </attribute>
    <attribute>
      <!-- volume-nr -->
      <change></change>
      <name>volumenr</name>
      <type>nVarchar(5)</type>
      <key>0</key>
      <index>0</index>
      <nullable></nullable>
    </attribute>
    <attribute>
      <!-- volumename -->
      <change></change>
      <name>volumename</name>
      <type>nVarchar(255)</type>
      <key>0</key>
      <index>0</index>
      <nullable></nullable>
    </attribute>
      <refAttribute>
        <!-- REFTEST Authors2 -->
        <change></change>
        <name>Authors</name>
        <refClass>Author2</refClass>
        <refClassAttrName>Books</refClassAttrName>
        <refTable>ref_author2_book2_01</refTable>
        <index>0</index>
        <BackEndDef></BackEndDef>
      </refAttribute>
    </class>
<!-- TESTCLASSES FINISHED -->
  <class id='Author' >
    <!-- AUTHOR CLASS -->
    <name>Author</name>
    <!-- Classname -->
    <change>create</change>
    <!-- Activity for Class -->
    <BackEndDef></BackEndDef>
    <!-- Script for Creation -->
    <attribute>
      <!-- firstname -->
      <change></change>
      <name>firstname</name>
      <type>nVarchar(MAX)</type>
      <key>0</key>
      <index>0</index>
      <nullable>NOT NULL</nullable>
    </attribute>
    <attribute>
      <!-- lastname -->
      <change></change>
      <name>lastname</name>
      <type>nVarchar(MAX)</type>
      <key>0</key>
      <index>0</index>
      <nullable>NOT NULL</nullable>
    </attribute>
    <refAttribute>
      <!-- REF Book -->
      <change></change>
      <name>Books</name>
      <refClass>Book</refClass>
      <refClassAttrName>Authors</refClassAttrName>
      <refTable>ref_author_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
  </class>
  <class id='City' >
    <!-- CITY CLASS -->
    <name>City</name>
    <!-- Classname -->
    <change>create</change>
    <!-- Activity for Class -->
    <BackEndDef></BackEndDef>
    <!-- Script for Creation -->
    <attribute>
      <!-- name -->
      <change></change>
      <name>name</name>
      <type>nVarchar(MAX)</type>
      <key>0</key>
      <index>0</index>
      <nullable>NOT NULL</nullable>
    </attribute>
    <refAttribute>
      <!-- REF Book -->
      <change></change>
      <name>Books</name>
      <refClass>Book</refClass>
      <refClassAttrName>Cities</refClassAttrName>
      <refTable>ref_city_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
  </class>
  <class id='Historicperson' >
    <!-- Historicperson CLASS -->
    <name>Historicperson</name>
    <!-- Classname -->
    <change>create</change>
    <!-- Activity for Class -->
    <BackEndDef></BackEndDef>
    <!-- Script for Creation -->
    <attribute>
      <!-- firstname -->
      <change></change>
      <name>firstname</name>
      <type>nVarchar(MAX)</type>
      <key>0</key>
      <index>0</index>
      <nullable>NOT NULL</nullable>
    </attribute>
    <attribute>
      <!-- lastname -->
      <change></change>
      <name>lastname</name>
      <type>nVarchar(MAX)</type>
      <key>0</key>
      <index>0</index>
      <nullable>NOT NULL</nullable>
    </attribute>
    <refAttribute>
      <!-- REF Book -->
      <change></change>
      <name>Books</name>
      <refClass>Book</refClass>
      <refClassAttrName>Historicpersons</refClassAttrName>
      <refTable>ref_historicperson_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
  </class>
  <class id='Book' >
    <!-- BOOK CLASS -->
    <name>Book</name>
    <!-- Classname -->
    <change>create</change>
    <!-- Activity for Class -->
    <BackEndDef></BackEndDef>
    <!-- Script for Creation -->
    <attribute>
      <!--title-->
      <change></change>
      <name>title</name>
      <type>nVarchar(MAX)</type>
      <key>0</key>
      <index>0</index>
      <nullable>NOT NULL</nullable>
    </attribute>
    <attribute>
      <!-- description -->
      <change></change>
      <name>description</name>
      <type>nVarchar(MAX)</type>
      <key>0</key>
      <index>0</index>
      <nullable></nullable>
    </attribute>
    <attribute>
      <!--pages -->
      <change></change>
      <name>pages</name>
      <type>int</type>
      <key>0</key>
      <index>0</index>
      <nullable></nullable>
    </attribute>
    <attribute>
      <!--readbook -->
      <change></change>
      <name>readbook</name>
      <type>bit</type>
      <key>0</key>
      <index>0</index>
      <nullable></nullable>
    </attribute>
    <attribute>
      <!-- price -->
      <change></change>
      <name>price</name>
      <type>float</type>
      <key>0</key>
      <index>0</index>
      <nullable></nullable>
    </attribute>
    <attribute>
      <!-- ISBN10 -->
      <change></change>
      <name>ISBN10</name>
      <type>nVarchar(20)</type>
      <key>0</key>
      <index>0</index>
      <nullable></nullable>
    </attribute>
    <attribute>
      <!-- ISBN13 -->
      <change></change>
      <name>ISBN13</name>
      <type>nVarchar(20)</type>
      <key>0</key>
      <index>0</index>
      <nullable></nullable>
    </attribute>
    <attribute>
      <!-- editiontype -->
      <change></change>
      <name>editiontype</name>
      <type>nVarchar(25)</type>
      <key>0</key>
      <index>0</index>
      <nullable></nullable>
    </attribute>
    <attribute>
      <!-- year -->
      <change></change>
      <name>year</name>
      <type>nVarchar(5)</type>
      <key>0</key>
      <index>0</index>
      <nullable></nullable>
    </attribute>
    <refAttribute>
      <!-- REF Authors -->
      <change></change>
      <name>Authors</name>
      <refClass>Author</refClass>
      <refClassAttrName>Books</refClassAttrName>
      <refTable>ref_author_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
    <refAttribute>
      <!-- REF cities -->
      <change></change>
      <name>cities</name>
      <refClass>City</refClass>
      <refClassAttrName>Books</refClassAttrName>
      <refTable>ref_city_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
    <refAttribute>
      <!-- REF historicperson -->
      <change></change>
      <name>Historicpersons</name>
      <refClass>historicperson</refClass>
      <refClassAttrName>Books</refClassAttrName>
      <refTable>ref_historicperson_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
    <refAttribute>
      <!-- REF Binding -->
      <change></change>
      <name>Binding</name>
      <refClass>Binding</refClass>
      <refClassAttrName>Books</refClassAttrName>
      <refTable>ref_binding_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
    <refAttribute>
      <!-- REF Category -->
      <change></change>
      <name>Category</name>
      <refClass>Category</refClass>
      <refClassAttrName>Category</refClassAttrName>
      <refTable>ref_category_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
    <refAttribute>
      <!-- REF Language -->
      <change></change>
      <name>Language</name>
      <refClass>Language</refClass>
      <refClassAttrName>Books</refClassAttrName>
      <refTable>ref_language_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
    <refAttribute>
      <!-- Series -->
      <change></change>
      <name>series</name>
      <refClass>Serie</refClass>
      <refClassAttrName>Books</refClassAttrName>
      <refTable>ref_serie_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
  </class>
  <class id='Category' >
    <!-- Category CLASS -->
    <name>Category</name>
    <!-- Classname -->
    <change>create</change>
    <!-- Activity for Class -->
    <BackEndDef></BackEndDef>
    <attribute>
      <!-- name -->
      <change></change>
      <name>Name</name>
      <type>nVarchar(MAX)</type>
      <key>0</key>
      <index>0</index>
      <nullable>NOT NULL</nullable>
    </attribute>
    <refAttribute>
      <!-- REF Books -->
      <change></change>
      <name>Books</name>
      <refClass>Book</refClass>
      <refClassAttrName>Category</refClassAttrName>
      <refTable>ref_category_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
  </class>
  <class id='Language' >
    <!-- Language CLASS -->
    <name>Language</name>
    <change>create</change>
    <BackEndDef></BackEndDef>
    <attribute>
      <!-- name -->
      <change></change>
      <name>Name</name>
      <type>nVarchar(MAX)</type>
      <key>0</key>
      <index>0</index>
      <nullable>NOT NULL</nullable>
    </attribute>
    <refAttribute>
      <!-- REF Books -->
      <change></change>
      <name>Books</name>
      <refClass>Book</refClass>
      <refClassAttrName>Language</refClassAttrName>
      <refTable>ref_language_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
  </class>
  <class id='Serie' >
    <!-- Serie CLASS -->
    <name>Serie</name>
    <change>create</change>
    <BackEndDef></BackEndDef>
    <attribute>
      <!-- name -->
      <change></change>
      <name>Name</name>
      <type>nVarchar(MAX)</type>
      <key>0</key>
      <index>0</index>
      <nullable>NOT NULL</nullable>
    </attribute>
    <refAttribute>
      <!-- REF Books -->
      <change></change>
      <name>Books</name>
      <refClass>Book</refClass>
      <refClassAttrName>Serie</refClassAttrName>
      <refTable>ref_serie_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
  </class>
  <class id='Binding' >
    <!-- Binding CLASS -->
    <name>Binding</name>
    <change>create</change>
    <BackEndDef></BackEndDef>
    <attribute>
      <!-- name -->
      <change></change>
      <name>Name</name>
      <type>nVarchar(MAX)</type>
      <key>0</key>
      <index>0</index>
      <nullable>NOT NULL</nullable>
    </attribute>
    <refAttribute>
      <!-- REF Books -->
      <change></change>
      <name>Books</name>
      <refClass>Book</refClass>
      <refClassAttrName>Binding</refClassAttrName>
      <refTable>ref_binding_book_01</refTable>
      <index>0</index>
      <BackEndDef></BackEndDef>
    </refAttribute>
  </class>
</definition>
